Forum Discussion
Transformer different rows of 1 column into multi column
Hi folks, A have a Excel Q&A Database with multiple questions and answers in differente sheets from diffentes people/companies, as example in below link to download from "mega.nz". https://m...
Greg_Deckler
Community Champion
Community ChampionNot entirely sure but it sounds like you want a Folder query.
Actualy, I have just one file (as example) but with many worksheet, and inside them, I have the questions/answers.
I will need probally at least one query for each worksheet, but I don't know how to "broke" the lines of the questions/options into columns (Master question / Question / Options).
BR.