Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-30-2023, 04:33 PM
Jane Jane is offline Create a file with Customer info on top line, and payments below from Power Query in Excel Windows 10 Create a file with Customer info on top line, and payments below from Power Query in Excel Office 2010
Novice
Create a file with Customer info on top line, and payments below from Power Query in Excel
 
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
Reply

Thread Tools
Display Modes


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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:04 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft