How to swop the excel column ?

[paulyeo1111]

Hi All

This is my first post.

I have excel file with below format :-

CUST_ID.............COMPANY...........INVOICE............DATE......................AMOUNT
1234.....................ABC........................123045..............12/11/2020.........1500
2324.....................XYZ........................120345...............11/11/2020.........2500
4544.....................DEF........................12345..................10/11/2020.........3500

May i know how to transform the above file structure to below format :-

COMPANY...........CUST_ID.........INVOICE..............DATE......................AMOUNT
ABC.........................1234...............123045.................12/11/2020......1500
ZYX .........................2324..............120345.................11/11/2020.......2500
DEF................... 4544..............12345...................10/11/2020........3500

Hope some one can advise me.

As i have many CSV file , i need to swop the column.

Paul

 

[JEC]

Load your file with power query, it needs just one step

 

[mohadin]

Hi
what about

Sub swap()
    With Sheets("sheet1").Cells(1).CurrentRegion
        .Resize(, 2) = Application.Index(.Resize(, 2), Evaluate("row(1:" & .Cells(Rows.Count, 1).End(xlUp).Row & ")"), Array(2, 1))
    End With
End Sub

 

[Rick Rothstein]

Load the data into Excel, then select Column A, hold down the Shift Key and place the cursor over the edge of the select column (cursor will turn to four arrows point away from the center), with the Shift Key still down left-click and drag the column to wherever you want (the column line between the columns will highlight) and release the mouse click and Shift Key.

 

[paulyeo1111]

Load your file with power query, it needs just one step

Thank you very much , i will try this approach. as i am using PBI.