Forum Discussion
BI Power Query Editor
Hi Rachel
If you don't need to keep <other info> rows when Fill Up and Keep Top rows (1)
As attached
How do you accomplish this?
Hi Rachel,
That's in Power Query editor ribbon
and
Thank you. I am also looking into potentially combining text files before importing them in to Excel. This would be what it would look like initially...
Description Site Building Dept Location
<description> null null null null
other info <site> <bldg> <dept> <locn>
other info null null null null
<description> null null null null
other info <site> <bldg> <dept> <locn>
other info null null null null
And this is what the end goal is:
Description Site Building Dept Location
<description> <site> <bldg> <dept> <locn>
<description2> <site2> <bldg2> <dept2> <locn2>
i'm not sure if this is feasible or not with Excel
