Create a file with Customer info on top line, and payments below from Power Query in Excel

Jane · #1 01-30-2023, 04:33 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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