Need to Pull from CSV rows into new sheet columns

E

edjohn20

New Member
Joined
Mar 5, 2024
Messages
26
Office Version
  1. 365
Platform
  1. Windows
  2. Mobile
I have attached the images sample 1 and sample 2. My data comes to me via sample 1 in row form however I have to import data via format sample 2. I only need the USD lines and cash dep lines are ignored.

sample 1.png
you can see location 609b gets 20's and 50's but it needs to be moved to this type of formatting

sample 2.png
and though the LOC ids aren't the same (i just used two different files) you can see how I need all the data for one LOC on one line.

Does anyone have an easy way to do this. I am having to manually create this sheet daily and it is killing time.
 
Sort by date Sort by votes
Ok you need to learn a small bit abut PQ , its in excel just another option, see below info from @alansidman

Power Query is a free AddIn for Excel 2010 and 2013, and is built-in functionality from Excel 2016 onwards (where it is referred to as "Get & Transform Data").

It is a powerful yet simple way of getting, changing and using data from a broad variety of sources, creating steps which may be easily repeated and refreshed. I strongly recommend learning how to use Power Query - it's among the most powerful functionalities of Excel.

- Follow this link to learn how to install Power Query in Excel 2010 / 2013.

- Follow this link for an introduction to Power Query functionality.

- Follow this link for a video which demonstrates how to use Power Query code provided.
 
Upvote 0

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
Kerryx said:
Code looks exactly the same as in power query when you click on "close & Load to" you select where you want the new data to be loaded , if its a new sheet select that option.
The code only filters to remove "Cash Dep" and then puts remaing data, your Denominations into whatever groups are there in your sheet.
If you had example of csv file the data could be loaded directly from that into PQ and processed,
View attachment 108796
Book1
ABCD
1LOCCurrencyDenominationCur
2 0609BUSDTwenties60000
3 0609BUSDFifties100000
4 0609BCash DepCash Dep0
5 0816CUSDTwenties70000
6 0816CUSDFifties100000
7 0816CCash DepCash Dep0
8 1242AUSDFifties140000
9 1242AUSDTwenties160000
10 1242ACash DepCash Dep0
11 1242HUSDTwenties50000
12 1242HUSDFifties100000
13 1242HCash DepCash Dep0
14 1670KUSDTwenties60000
15 0609BCash DepCash Dep0
16 0816CUSDFives5
17 1242HUSDOnes1
18 1670KUSDHundreds100
191456GUSDThousands1000
Sheet1



Book1
ABCDEFG
1Count.LOCTwentiesFiftiesFivesOnesHundredsThousands
2 0609B60000100000
3 0816C700001000005
4 1242A160000140000
5 1242H500001000001
6 1670K60000100
71456G1000
Table1
Click to expand...
Ok so I am in the power query advance editor. I have gotten it to the point that it is saying a syntax error. This is mainly due to me only showing a select few cells and some of the header rows changed names. I am going to post the script so that maybe it will help smooth things out. I am sure it is due to omitting a lot of the other columns that I knew would be unchanged but now looking at it, it would have been best to include it all. the "Promoted Headers" is exactly what is coming in. I don't need currency moved at all.

If this makes it more confusing, let me know and I will start all over.


Excel Formula: 
let
    Source = Csv.Document(File.Contents("C:\Users\agent\OneDrive\Documents\3-12.csv"),[Delimiter=",", Columns=15, Encoding=1252, QuoteStyle=QuoteStyle.Csv]),
    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Company_Name", type text}, {"Filter_name", type text}, {"Request_ID", Int64.Type}, {"Print_Date", type date}, {"Transport", type text}, {"Delivery_Date", type date}, {"AU_Number", Int64.Type}, {"Route", type text}, {"Local#(lf)", type text}, {"Local#(lf)_1", type text}, {"ATM ID", type text}, {"Currency", type text}, {"Denomination", type text}, {"Current_Load", Int64.Type}, {"Fill_Method", type text}}),
    #"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([Denomination] <> "Cash Dep ")),
    #"Removed Columns" = Table.RemoveColumns(#"Filtered Rows",{"Currency"}),
    #"Grouped Rows" = Table.Group(#"Removed Columns", {"Denomination"}, {{"Count", each _, type table [ATM ID=nullable text, Denomination=nullable text, Current_Load=nullable number]}}),
    #"Expanded Count" = Table.ExpandTableColumn(#"Grouped Rows", "Count", {"ATM ID", "Current_Load"}, {"Count.ATM ID", "Count.Current_Load"}),
    #"Pivoted Column" = Table.Pivot(#"Expanded Count", List.Distinct(#"Expanded Count"[Denomination]), "Denomination", "Count.Current_Load")
in
 
Upvote 0
Solution
Ok so this info shows you have 15 columns of information instead of just 4 as in your example. If this is what you are getting
1711039419855.png

it is possible you have omitted the last line in your code , it should be
Power Query: 
in
#"Pivoted Column"

you seem to have missed the piece that says #"Pivoted Column"
 
Upvote 0
Dont forget you can delete columns in PQ thet you dont need before you load the info into excel , just add the steps as you need them
 
Upvote 0
Kerryx said:
Dont forget you can delete columns in PQ thet you dont need before you load the info into excel , just add the steps as you need them
Click to expand...
didn't realize this post went to two pages already. So here is what I have so far and it appears to be working. BUT since I limited my information in the beginning it isn't there. I need to display all the columns at the very end with exception to CURRENCY

here is current code that is working "ish"

Excel Formula: 
let
    Source = Csv.Document(File.Contents("C:\Users\agent\OneDrive\Documents\3-12.csv"),[Delimiter=",", Columns=15, Encoding=1252, QuoteStyle=QuoteStyle.Csv]),
    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Company_Name", type text}, {"Filter_name", type text}, {"Request_ID", Int64.Type}, {"Print_Date", type date}, {"Transport", type text}, {"Delivery_Date", type date}, {"AU_Number", Int64.Type}, {"Route", type text}, {"Local#(lf)", type text}, {"Local#(lf)_1", type text}, {"ATM ID", type text}, {"Currency", type text}, {"Denomination", type text}, {"Current_Load", Int64.Type}, {"Fill_Method", type text}}),
    #"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([Denomination] <> "Cash Deposit Pull")),
    #"Removed Columns" = Table.RemoveColumns(#"Filtered Rows",{"Currency"}),
    #"Grouped Rows" = Table.Group(#"Removed Columns", {"Denomination"}, {"Count", each _, type table [ATM ID=nullable text, Denomination=nullable text, Current_Load=nullable number, Fill_Method=nullable text]}),
    #"Expanded Count" = Table.ExpandTableColumn(#"Grouped Rows", "Count", {"ATM ID", "Current_Load"}, {"ATM ID", "Current_Load"}),
    #"Pivoted Column" = Table.Pivot(#"Expanded Count", List.Distinct(#"Expanded Count"[Denomination]), "Denomination", "Current_Load")
in
#"Pivoted Column"
 
Upvote 0
edjohn20 said:
didn't realize this post went to two pages already. So here is what I have so far and it appears to be working. BUT since I limited my information in the beginning it isn't there. I need to display all the columns at the very end with exception to CURRENCY

here is current code that is working "ish"

Excel Formula: 
let
    Source = Csv.Document(File.Contents("C:\Users\agent\OneDrive\Documents\3-12.csv"),[Delimiter=",", Columns=15, Encoding=1252, QuoteStyle=QuoteStyle.Csv]),
    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Company_Name", type text}, {"Filter_name", type text}, {"Request_ID", Int64.Type}, {"Print_Date", type date}, {"Transport", type text}, {"Delivery_Date", type date}, {"AU_Number", Int64.Type}, {"Route", type text}, {"Local#(lf)", type text}, {"Local#(lf)_1", type text}, {"ATM ID", type text}, {"Currency", type text}, {"Denomination", type text}, {"Current_Load", Int64.Type}, {"Fill_Method", type text}}),
    #"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([Denomination] <> "Cash Deposit Pull")),
    #"Removed Columns" = Table.RemoveColumns(#"Filtered Rows",{"Currency"}),
    #"Grouped Rows" = Table.Group(#"Removed Columns", {"Denomination"}, {"Count", each _, type table [ATM ID=nullable text, Denomination=nullable text, Current_Load=nullable number, Fill_Method=nullable text]}),
    #"Expanded Count" = Table.ExpandTableColumn(#"Grouped Rows", "Count", {"ATM ID", "Current_Load"}, {"ATM ID", "Current_Load"}),
    #"Pivoted Column" = Table.Pivot(#"Expanded Count", List.Distinct(#"Expanded Count"[Denomination]), "Denomination", "Current_Load")
in
#"Pivoted Column"
Click to expand...
So I am not super familiar with PQ but it is coming along, however now matter what I change in the code I cannot seem to make it produce all oringinal columns (removing the currency column) and then inserting the denominations in between ATM ID and Current LOAD
 
Upvote 0
Kerryx said:
Dont forget you can delete columns in PQ thet you dont need before you load the info into excel , just add the steps as you need them
Click to expand...
So I am not super familiar with PQ but it is coming along, however now matter what I change in the code I cannot seem to make it produce all oringinal columns (removing the currency column) and then inserting the denominations in between ATM ID and Current LOAD
 
Upvote 0
Any chance you could give us something with all the columns as I am working blind here, unless someone else wants to jump in and assist
 
Upvote 0
Ok decided to give a head start is it something like this
Book1
ABCDEFGHIJKLMNO
1Company_NameFilter_NameRequest IDPrint DateTransportDelivery DateAU_NumberRouteLocal#(If)Local#(If)_1ATM IDCurrencyDenominationCurrent_LoadFill_Method
2AFilt101/02/2024Truck04/02/2024123111 0609BUSDTwenties60000Manual
3AFilt102/02/2024Truck04/02/2024123111 0609BUSDFifties100000Manual
4AFilt103/02/2024Truck04/02/2024123111 0609BCash DepCash Dep0Manual
5BFilt204/02/2024Truck04/02/2024456222 0816CUSDTwenties70000Manual
6BFilt205/02/2024Truck04/02/2024456222 0816CUSDFifties100000Manual
7BFilt206/02/2024Truck04/02/2024456222 0816CCash DepCash Dep0Manual
8CFilt307/02/2024Truck04/02/2024789333 1242AUSDFifties140000Manual
9CFilt308/02/2024Truck04/02/2024789333 1242AUSDTwenties160000Manual
10CFilt309/02/2024Truck04/02/2024789333 1242ACash DepCash Dep0Manual
11DFilt410/02/2024Truck04/02/2024741444 1242HUSDTwenties50000Manual
12DFilt411/02/2024Truck04/02/2024741444 1242HUSDFifties100000Manual
13DFilt412/02/2024Truck04/02/2024741444 1242HCash DepCash Dep0Manual
14EFilt513/02/2024Truck05/02/2024852555 1670KUSDTwenties60000Auto
15FFilt614/02/2024Truck05/02/2024852666 0609BCash DepCash Dep0Auto
16BFilt715/02/2024Truck05/02/2024852777 0816CUSDFives5Auto
17DFilt816/02/2024Truck05/02/2024741888 1242HUSDOnes1Auto
18FFilt917/02/2024Truck05/02/2024963999 1670KUSDHundreds100Auto
19GFilt1018/02/2024Truck05/02/20247531010101456GUSDThousands1000Auto
Sheet1



Book1
ABCDEFGHIJKLMNOPQR
1Count.Company_NameCount.Filter_NameCount.Request IDCount.Print DateCount.TransportCount.Delivery DateCount.AU_NumberCount.RouteCount.Local#(If)Count.Local#(If)_1Count.ATM IDCount.Fill_MethodTwentiesFiftiesFivesOnesHundredsThousands
2AFilt101/02/2024Truck04/02/2024123111 0609BManual60000
3AFilt102/02/2024Truck04/02/2024123111 0609BManual100000
4BFilt204/02/2024Truck04/02/2024456222 0816CManual70000
5BFilt205/02/2024Truck04/02/2024456222 0816CManual100000
6BFilt715/02/2024Truck05/02/2024852777 0816CAuto5
7CFilt307/02/2024Truck04/02/2024789333 1242AManual140000
8CFilt308/02/2024Truck04/02/2024789333 1242AManual160000
9DFilt410/02/2024Truck04/02/2024741444 1242HManual50000
10DFilt411/02/2024Truck04/02/2024741444 1242HManual100000
11DFilt816/02/2024Truck05/02/2024741888 1242HAuto1
12EFilt513/02/2024Truck05/02/2024852555 1670KAuto60000
13FFilt917/02/2024Truck05/02/2024963999 1670KAuto100
14GFilt1018/02/2024Truck05/02/20247531010101456GAuto1000
Table1 (2)


As you can see in the line with Expanded Count you select all the columns you want to show so i removed Currency as you said you don't need it and Denomination is what we are grouping by so you can take that out also to prevent duplication

Power Query: 
let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Company_Name", type text}, {"Filter_Name", type text}, {"Request ID", Int64.Type}, {"Print Date", type date}, {"Transport", type text}, {"Delivery Date", type date}, {"AU_Number", Int64.Type}, {"Route", Int64.Type}, {"Local#(#)(If)", Int64.Type}, {"Local#(#)(If)_1", Int64.Type}, {"ATM ID", type text}, {"Currency", type text}, {"Denomination", type text}, {"Current_Load", Int64.Type}, {"Fill_Method", type text}}),
    #"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([Currency] = "USD")),
    #"Grouped Rows" = Table.Group(#"Filtered Rows", {"Denomination"}, {{"Count", each _, type table [Company_Name=nullable text, Filter_Name=nullable text, Request ID=nullable number, Print Date=nullable date, Transport=nullable text, Delivery Date=nullable date, AU_Number=nullable number, Route=nullable number, #"Local#(#)(If)"=nullable number, #"Local#(#)(If)_1"=nullable number, ATM ID=nullable text, Currency=nullable text, Denomination=nullable text, Current_Load=nullable number, Fill_Method=nullable text]}}),
    #"Expanded Count" = Table.ExpandTableColumn(#"Grouped Rows", "Count", {"Company_Name", "Filter_Name", "Request ID", "Print Date", "Transport", "Delivery Date", "AU_Number", "Route", "Local#(#)(If)", "Local#(#)(If)_1", "ATM ID", "Current_Load", "Fill_Method"}, {"Count.Company_Name", "Count.Filter_Name", "Count.Request ID", "Count.Print Date", "Count.Transport", "Count.Delivery Date", "Count.AU_Number", "Count.Route", "Count.Local#(#)(If)", "Count.Local#(#)(If)_1", "Count.ATM ID", "Count.Current_Load", "Count.Fill_Method"}),
    #"Pivoted Column" = Table.Pivot(#"Expanded Count", List.Distinct(#"Expanded Count"[Denomination]), "Denomination", "Count.Current_Load")
in
    #"Pivoted Column"
 
Upvote 0
Kerryx said:
Ok decided to give a head start is it something like this
Book1
ABCDEFGHIJKLMNO
1Company_NameFilter_NameRequest IDPrint DateTransportDelivery DateAU_NumberRouteLocal#(If)Local#(If)_1ATM IDCurrencyDenominationCurrent_LoadFill_Method
2AFilt101/02/2024Truck04/02/2024123111 0609BUSDTwenties60000Manual
3AFilt102/02/2024Truck04/02/2024123111 0609BUSDFifties100000Manual
4AFilt103/02/2024Truck04/02/2024123111 0609BCash DepCash Dep0Manual
5BFilt204/02/2024Truck04/02/2024456222 0816CUSDTwenties70000Manual
6BFilt205/02/2024Truck04/02/2024456222 0816CUSDFifties100000Manual
7BFilt206/02/2024Truck04/02/2024456222 0816CCash DepCash Dep0Manual
8CFilt307/02/2024Truck04/02/2024789333 1242AUSDFifties140000Manual
9CFilt308/02/2024Truck04/02/2024789333 1242AUSDTwenties160000Manual
10CFilt309/02/2024Truck04/02/2024789333 1242ACash DepCash Dep0Manual
11DFilt410/02/2024Truck04/02/2024741444 1242HUSDTwenties50000Manual
12DFilt411/02/2024Truck04/02/2024741444 1242HUSDFifties100000Manual
13DFilt412/02/2024Truck04/02/2024741444 1242HCash DepCash Dep0Manual
14EFilt513/02/2024Truck05/02/2024852555 1670KUSDTwenties60000Auto
15FFilt614/02/2024Truck05/02/2024852666 0609BCash DepCash Dep0Auto
16BFilt715/02/2024Truck05/02/2024852777 0816CUSDFives5Auto
17DFilt816/02/2024Truck05/02/2024741888 1242HUSDOnes1Auto
18FFilt917/02/2024Truck05/02/2024963999 1670KUSDHundreds100Auto
19GFilt1018/02/2024Truck05/02/20247531010101456GUSDThousands1000Auto
Sheet1



Book1
ABCDEFGHIJKLMNOPQR
1Count.Company_NameCount.Filter_NameCount.Request IDCount.Print DateCount.TransportCount.Delivery DateCount.AU_NumberCount.RouteCount.Local#(If)Count.Local#(If)_1Count.ATM IDCount.Fill_MethodTwentiesFiftiesFivesOnesHundredsThousands
2AFilt101/02/2024Truck04/02/2024123111 0609BManual60000
3AFilt102/02/2024Truck04/02/2024123111 0609BManual100000
4BFilt204/02/2024Truck04/02/2024456222 0816CManual70000
5BFilt205/02/2024Truck04/02/2024456222 0816CManual100000
6BFilt715/02/2024Truck05/02/2024852777 0816CAuto5
7CFilt307/02/2024Truck04/02/2024789333 1242AManual140000
8CFilt308/02/2024Truck04/02/2024789333 1242AManual160000
9DFilt410/02/2024Truck04/02/2024741444 1242HManual50000
10DFilt411/02/2024Truck04/02/2024741444 1242HManual100000
11DFilt816/02/2024Truck05/02/2024741888 1242HAuto1
12EFilt513/02/2024Truck05/02/2024852555 1670KAuto60000
13FFilt917/02/2024Truck05/02/2024963999 1670KAuto100
14GFilt1018/02/2024Truck05/02/20247531010101456GAuto1000
Table1 (2)


As you can see in the line with Expanded Count you select all the columns you want to show so i removed Currency as you said you don't need it and Denomination is what we are grouping by so you can take that out also to prevent duplication

Power Query: 
let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Company_Name", type text}, {"Filter_Name", type text}, {"Request ID", Int64.Type}, {"Print Date", type date}, {"Transport", type text}, {"Delivery Date", type date}, {"AU_Number", Int64.Type}, {"Route", Int64.Type}, {"Local#(#)(If)", Int64.Type}, {"Local#(#)(If)_1", Int64.Type}, {"ATM ID", type text}, {"Currency", type text}, {"Denomination", type text}, {"Current_Load", Int64.Type}, {"Fill_Method", type text}}),
    #"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([Currency] = "USD")),
    #"Grouped Rows" = Table.Group(#"Filtered Rows", {"Denomination"}, {{"Count", each _, type table [Company_Name=nullable text, Filter_Name=nullable text, Request ID=nullable number, Print Date=nullable date, Transport=nullable text, Delivery Date=nullable date, AU_Number=nullable number, Route=nullable number, #"Local#(#)(If)"=nullable number, #"Local#(#)(If)_1"=nullable number, ATM ID=nullable text, Currency=nullable text, Denomination=nullable text, Current_Load=nullable number, Fill_Method=nullable text]}}),
    #"Expanded Count" = Table.ExpandTableColumn(#"Grouped Rows", "Count", {"Company_Name", "Filter_Name", "Request ID", "Print Date", "Transport", "Delivery Date", "AU_Number", "Route", "Local#(#)(If)", "Local#(#)(If)_1", "ATM ID", "Current_Load", "Fill_Method"}, {"Count.Company_Name", "Count.Filter_Name", "Count.Request ID", "Count.Print Date", "Count.Transport", "Count.Delivery Date", "Count.AU_Number", "Count.Route", "Count.Local#(#)(If)", "Count.Local#(#)(If)_1", "Count.ATM ID", "Count.Current_Load", "Count.Fill_Method"}),
    #"Pivoted Column" = Table.Pivot(#"Expanded Count", List.Distinct(#"Expanded Count"[Denomination]), "Denomination", "Count.Current_Load")
in
    #"Pivoted Column"
Click to expand...
I appreciate ALL of your help. Here is what I came up with for final revision. Let me know if there is something simpler or more efficient means.

SQL: 
let
    Source = Csv.Document(File.Contents("C:\Users\agent\OneDrive\Documents\3-12.csv"),[Delimiter=",", Columns=15, Encoding=1252, QuoteStyle=QuoteStyle.Csv]),
    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Company_Name", type text}, {"Filter_name", type text}, {"Request_ID", Int64.Type}, {"Print_Date", type date}, {"Transport", type text}, {"Delivery_Date", type date}, {"AU_Number", Int64.Type}, {"Route", type text}, {"Local#(lf)", type text}, {"Local#(lf)_1", type text}, {"ATM ID", type text}, {"Currency", type text}, {"Denomination", type text}, {"Current_Load", Int64.Type}, {"Fill_Method", type text}}),
    #"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([Currency] = "USD")),
    #"Grouped Rows" = Table.Group(#"Filtered Rows", {"Denomination"}, {{"Count", each _, type table [Company_Name=nullable text, Filter_Name=nullable text, Request_ID=nullable number, Print_Date=nullable date, Transport=nullable text, Delivery_Date=nullable date, AU_Number=nullable number, Route=nullable number, #"Local#(lf)"=nullable number, #"Local#(lf)_1"=nullable number, ATM ID=nullable text, Currency=nullable text, Denomination=nullable text, Current_Load=nullable number, Fill_Method=nullable text]}}),
    #"Expanded Count" = Table.ExpandTableColumn(#"Grouped Rows", "Count", {"Company_Name", "Filter_Name", "Request_ID", "Print_Date", "Transport", "Delivery_Date", "AU_Number", "Route", "Local#(lf)", "Local#(lf)_1", "ATM ID", "Current_Load", "Fill_Method"}, {"Count.Company_Name", "Count.Filter_Name", "Count.Request_ID", "Count.Print_Date", "Count.Transport", "Count.Delivery_Date", "Count.AU_Number", "Count.Route", "Count.Local#(lf)", "Count.Local#(lf)_1", "Count.ATM ID", "Count.Current_Load", "Count.Fill_Method"}),
    #"Pivoted Column" = Table.Pivot(#"Expanded Count", List.Distinct(#"Expanded Count"[Denomination]), "Denomination", "Count.Current_Load"),
    #"Reordered Columns" = Table.ReorderColumns(#"Pivoted Column",{"Count.Company_Name", "Count.Filter_Name", "Count.Request_ID", "Count.Print_Date", "Count.Transport", "Count.Delivery_Date", "Count.AU_Number", "Count.Route", "Count.Local#(lf)", "Count.Local#(lf)_1", "Count.ATM ID", "Twenties", "Fifties", "Hundreds", "Count.Fill_Method"}),
    #"Renamed Columns" = Table.RenameColumns(#"Reordered Columns",{{"Count.Company_Name", "Company_Name"}, {"Count.Filter_Name", "Filter_Name"}, {"Count.Request_ID", "Request_ID"}, {"Count.Print_Date", "Print_Date"}, {"Count.Transport", "Transport"}, {"Count.Delivery_Date", "Delivery_Date"}, {"Count.AU_Number", "AU_Number"}, {"Count.Route", "Route"}, {"Count.Local#(lf)", "Local#(lf)"}, {"Count.Local#(lf)_1", "Local#(lf)_1"}, {"Count.ATM ID", "ATM ID"}, {"Count.Fill_Method", "Fill_Method"}})
in
    #"Renamed Columns"
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Question
VBA Macro to combine two row data into one row
Replies
1
Views
172
iggydarsa
iggydarsa
M
  • Question
Getting Power Query data to an Excel worksheet
Replies
4
Views
207
MichaelMorris
M
D
  • Question
CSV From Quickbooks Issue
Replies
1
Views
63
Alex Blakenburg
A
M
  • Question
Pull data from a table into a specific structure at another sheet
Replies
4
Views
311
murka
M
H
  • Question
Avoiding INDIRECT when referencing and comparing ranges in different workbooks
Replies
1
Views
288
RoryA
RoryA

Forum statistics

Threads
1,215,073
Messages
6,122,970
Members
449,095
Latest member
Mr Hughes

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top