Forum Discussion
Solved
Assist with moving data in a different structure way...
hello all,
currently my data is structured at the table below:
| 1/3/2022 | 1/5/2022 | 1/10/2022 | |
| Item 1 | 626 | ||
| Item 2 | 1,575 | ||
| Item 3 | 255 | 255 |
and i would like to have it as the table below:
| Item 1 | 626 | 1/5/2022 |
| Item 2 | 1,575 | 1/5/2022 |
| Item 3 | 255 | 1/3/2022 |
| Item 3 | 255 | 1/10/2022 |
any formula as if i can move that to the way i want it?
thank you
Try the Unpivot Columns feature of the Query Editor (Data tab of the ribbon > Get Data > From Other Sources > From Table/Range).
1 Reply
Try the Unpivot Columns feature of the Query Editor (Data tab of the ribbon > Get Data > From Other Sources > From Table/Range).