Forum Discussion
Combining data as columns rather than rows
Hello, I am new to power query and trying to find a solution to a problem I am having with trying to combine files. Power query usually combines files into rows. each of my files have abou...
Hi apourgha ,
If you are only searching for rows, you can use:
1. Apply filter
2. Add a custom step: Table.FindText(TableNames/PreviousStep, "Keyword")
if the above suggestion does not suit your situation, you can:
1. Merge Wavelength_file1. & Reflectance_file1. columns then pivot the merged column, which should give you the layout as below.
wavelength_file1Reflectance_file1wavelength_file2Reflectance_file2Wavelength_file3Reflectance_file3
Regards
KT