I would like to Transpose data from table A to table B, please help.
I try to use excel Transpose data, however I don't know what should I do
Asked
Active
Viewed 56 times
0
-
are you happy to use VBA? – Mertinc Jan 19 '23 at 03:27
-
2You are not transposing, you are unpivoting. – VBasic2008 Jan 19 '23 at 03:51
-
1Please check the following [answer](https://stackoverflow.com/questions/74435042/excel-split-rows-of-table-in-multiple-rows-based-on-different-cell-values/74436257#74436257), it is a similar problem applied to a different dataset. – David Leal Jan 19 '23 at 04:05
-
1Power Query an option ? – P.b Jan 19 '23 at 07:50
-
1Voted to close as dup. Both answers will show you how to unpivot data. Let us know if you are helped. If not, we can vote to re-open. – JvdV Jan 19 '23 at 07:57