Thread: Create a file with Customer info on top line, and payments below from Power Query in Excel
View Single Post
 
Old 01-30-2023, 04:33 PM
Jane Jane is offline Windows 10 Office 2010
Novice
  
Join Date: Jan 2023
Posts: 1
Jane is on a distinguished road
Question 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
Reply With Quote