Create an array from matching values in multiple columns

I want to create a table like this (Similar to a pivot table)

........Tag1......Tag2......Tag3......Tag4.....Tag5........Tagn
ID1
ID2
ID3
ID4

From Data that looks like this:
(I have an ID field, and 5 columns with an assortment of tags)

ID#.....TAG......TAG.....TAG.....TAG.....TAG
ID1......Tag2....Tag5....Tag3....Tag7.....Tagn
ID2......Tag5....Tag1
ID3......Tag3
ID4......Tag6....Tag1...Tag20..Tag8

I have created one list of Tags and removed duplicates, then transposed them to make them column headings, which has created the structure of the table at the top.
I have managed to get it working (sort of) by adding the new, complete tags list to the original data and using that as the "Columns" in a pivot and adding each of the tag columns as "Values", but I end up with a table like this:

.......Tag1.....................................................Tag2.......................................................Tag3 Tag4 Tag5 .... Tagn
.......TAG.....TAG....TAG....TAG....TAG.............TAG......TAG....TAG....TAG....TAG..............etc.
ID1...1....................1.........1...........................1..........1.............................1
ID2..............1.........1.........1.......................................1........1
ID3..............1.................................................1
ID4...1.......................................................................1

........|_____________________________|
.........Now I need to group these back into one column, and there are over 600 Tags


Any idea on a better way of doing this, I'm sure there is a very simple solution I am missing/ unaware of.

Any help appreciated.

Hello Fresh_Outlook and Welcome to Excel Forum.
If the data is in the form shown in the middle of post #1 and you would like to transform it into a pivot table, and since you are using the subscription version (365) of Excel, I feel that using power query to transform the data into normal records then applying a pivot table to that would be a way to go about this.
If you would like for us to look into the above as a possibility please upload a small desensitized sample of the data along with your expected output (manually typed).
To upload a sample spreadsheet (not a picture or pasted copy) click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
Let us know if you have any questions.