CSV Second Row is the Header and Split a collum based off the tabs into multiple columns

Question

Good day,&nbsp;I receive an automated CSV file daily on a SH Document library location.&nbsp;&nbsp;1. The first row is a general message; when importing via WEB URL from SH, how do I make the second row my header?2. I also have a dimensional column that I want to split into multiple columns based on the row/cell number of "TAB" (Country (O TAB), Region (1 TAB), City (2 TABS)). Here is an example of the value&nbsp; &nbsp;Collumn: Location&nbsp; &nbsp;Row1: South Africa&nbsp; &nbsp;Row2: "TAB"&nbsp; &nbsp;Western Cape&nbsp; &nbsp;Row2: "TAB"&nbsp;"TAB"&nbsp; &nbsp; Cape Town&nbsp;Please Help with any ideas&nbsp;Regards

akash_varuna · Accepted Answer

Hi&nbsp;icassiem&nbsp;Try this please&nbsp;Make Second Row the Header:Remove the first row in Power Query (Remove Rows &gt; Remove Top Rows).Promote the second row as headers (Transform &gt; Use First Row as Headers).Split "Location" Column by "TAB":Replace "TAB" with a delimiter like | (Transform &gt; Replace Values).Split the column by the delimiter (Transform &gt; Split Column &gt; By Delimiter).Trim spaces (Transform &gt; Trim).If this post helped please do give a kudos and accept this as a solutionThanks In Advance

Forum Discussion

CSV Second Row is the Header and Split a collum based off the tabs into multiple columns

2 Replies

Related content

Sequential Order column based on multiple criteria

Multiple line and clustered columns chart

How to include multiple columns in Activator

Summarize Multiple Columns

Conditional Column with Multiple Conditions