Display multiple tables with the same fields as one table

It might help to understand the overall process or context this task is part of. A few thoughts that may or may not be part of working out a solution:

1) You are extracting data from somewhere (OS information?) using Power Shell, and Power Shell is generating a single column of data in a text file. It appears that your end goal is to get this data compiled and stored into a nice data base that you can then analyze further. Did I guess right?
2) Does Power Shell have any other output options other than the "single column text file" output? Some of this might be easier to do if you can get Power Shell to do it.
3) Are you required to use Excel for this processing? A dedicated database app may have better tools for manipulating text files into a good data base. If you want to do this in Excel, Power Query/Get and Transform seems to be a good tool for working with data in text files and then shaping the data into a good database.

I don't do database work, so I am not very helpful with specifics. Perhaps something in those thoughts will prompt some research and discussion that will help you find a good solution to your task.

I am a non-user of Power Query, so I have no tips. An internet search for "power query manipulate text files" found:
https://docs.microsoft.com/en-us/pow...y/combinefiles which should also provide a gateway into the rest of Microsoft's documentation on Power Query.
Power Query uses an "M" language, and this should provide a gateway into that documentation: https://docs.microsoft.com/en-us/pow...text-functions
A tutorial for beginners: https://powerspreadsheets.com/excel-...uery-tutorial/

I know that other users are familiar with Power Query, so searching this forum may be useful.

Using your first download in Post #1
Here is the Mcode from Power Query

Please Login or Register  to view this content.

Attached is the file for your review.

Excel 2016 (Windows) 32 bit

	A	B	C	D
1	Name	FullName	Disabled	Description
2	username1	first1 last1	False	user desc1
3	username2	first2 last2	False	user desc2
4	username3	first3 last3	False	user desc3
5	username4	first4 last4	False	user desc4
6	username5	first5 last5	False	user desc5

Sheet: Sheet1

In the attached file
Click on any cell in the new table
On the Data Tab, click on Queries & Connections
In the right window, double click to open Query
Review PQ steps
M-code basics:
- "let" is the start of a query
- "in" is the closing of a query
- each transformation step sits in between those 2 lines
- each step line is ended by a comma, except the last one
- "Source" is always the first step (Source Data)
- After "in" you have the last step referenced

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.