Transform Excel table columns not all into rows - long to wide transformation

Question

Need to convert the columns in an Excel table to rows. I attempted to replace the value fields in a pivot table with its underlying data by text-converting the pivot table's values, but I was unable (to show them as text). I'm open to trying an alternate strategy for changing the relevant table.

I tried utilizing Power Query, unpivoting columns, and transposing, but I was unable to achieve the desired outcome.

Due to the fact that the current table contains more than 2,000 rows with legal names but only three separate groups for such rows, placing the group names side by side makes them easier to read and remember. The table's structure is similar to the records below:

Group	Legal Name	DBA
A	2023 LTD, Inc	2023 LTD Inc
B	2023 LTD, Inc	2023 LTD
C	2023 LTD, Inc	2023 LTD Inc.
A	XYZ Enterprises	XYZ Enterprises Inc.
A	Aerotec, LLC	Aerotec
B	Aerotec, LLC	Aerotec LLC.
C	Aerotec, LLC	Aero

Desired Result:

Legal Name	A	B	C
2023 LTD, Inc	2023 LTD Inc	2023 LTD	2023 LTD Inc.
XYZ Enterprises	XYZ Enterprises Inc.
Aerotec, LLC	Aerotec	Aerotec LLC.	Aero

This image portrays what it is shown in the above tables but with additional records to show realistic examples

Answer 1

In PQ, highlight the Group column and select pivot from the ribbon.

Fill in as follows and you're done: