Forum Discussion
Solved
Table Transformation - Column Names into Repeated rows
BI Experts, I am attempting to perform a batch import of excel files from a folder where the native data structure for one table is: Service Name Sales Person A Sales Person X Sales Per...
Hey DEngel ,
I think that if you bring in the data as shown in the first image and then do a transpose or pivot on the columns after the first one you should be able to get the result that you want.
I took this:
I selected the first column and unpivoted the other ones:
and got this
Thanks a ton Collin, that worked perfectly to be able to manage one file.
I am working through a couple of issues with file structures varying (between each) and having to manage to use techniques like that stated here: Solved: Replacing a specific value in ALL cells, without h... - Microsoft Fabric Community
Unsure if you know of a similar approach for replacing errors for all columns.
