|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Create a file with Customer info on top line, and payments below from Power Query in Excel
Hi,
I have a Power Query retrieving all customer data in one line for a customer, which includes the File info (line1), Customer payment (Line 2), each payment records (line3-4) for a customer and footer (line 5). The file contains several customers. Now I need to line the data in the format below. Could you help to make it possible? F 1 231.00 000000001 T P CHK 1012345678 231.00 388 Greenwich Street New York NY 10013 US R INV123 120.12 202000401 ACCT456 ID789 PO234 R INV124 110.88 202000401 ACCT456 ID790 PO235 N Payment for Widgets shipped Nome AK Thanks in advance! Jane |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel Power Query Not Returning All Rows | rspiet | Excel | 1 | 03-28-2022 05:51 AM |
Excel power query help | ganesang | Excel Programming | 0 | 09-20-2021 01:50 AM |
Issues Using Power Query file in Excel 2016 and then in 2013 | bld9936 | Excel Programming | 0 | 02-27-2017 12:50 PM |
Query and Power Query not working Excel 2016 | bl10 | Excel | 0 | 07-22-2016 06:25 PM |
Info from excel spreadsheet to Power point | anyquist | Office | 0 | 01-31-2011 12:29 PM |