Hello!
First time poster here. I am an excel novice. Long story short, I have a large .CSV spreadsheet where I need to automatically remove unused/blank columns. However the columns that end up empty will be different every time. I have tried using Power-Query to solve this issue but I only see a button for "remove blank rows" there does not seem to be a button for "remove blank columns". I tried "transforming" the data, then hitting the "remove blank rows" button and then "transforming" the data back. This works, but I lose my header names and I cannot have that. So I was wondering if anyone here could point me in the right direction of a quick and simple solution. Is there another power BI tool or piece of software that will support this function? Is there a way to do this in PQ that I'm just not seeing? By the way I am aware that columns can be removed manually but sometimes I end up with hundreds of different blank columns throughout my data that all need to be removed in a timely fashion. Any help would be greatly appreciated.
Thanks.
First time poster here. I am an excel novice. Long story short, I have a large .CSV spreadsheet where I need to automatically remove unused/blank columns. However the columns that end up empty will be different every time. I have tried using Power-Query to solve this issue but I only see a button for "remove blank rows" there does not seem to be a button for "remove blank columns". I tried "transforming" the data, then hitting the "remove blank rows" button and then "transforming" the data back. This works, but I lose my header names and I cannot have that. So I was wondering if anyone here could point me in the right direction of a quick and simple solution. Is there another power BI tool or piece of software that will support this function? Is there a way to do this in PQ that I'm just not seeing? By the way I am aware that columns can be removed manually but sometimes I end up with hundreds of different blank columns throughout my data that all need to be removed in a timely fashion. Any help would be greatly appreciated.
Thanks.