I need help organizing a bunch of data I have. I cannot for the life of my figure out a effective way to automatically format it to the needed format.

I have a list of multiple programs that contain what file types that are compatible with and need to rearrange the data to determine the relationships between them all.

For example see below, " | " indicates column break. (Just 3 columns);

Adobe Reader | Import | PDF
Adobe Reader | Export | PDF
Microsoft Excel | Export | XLSX
Paint | Export | JPEG

I need to rearrange the data above to be like below (5 columns):


Adobe Reader | PDF;JPEG | Excel;Paint | PDF;PDF;DOC | NitroPDF;Adobe Pro;Microsoft Word


The entire row is for Adobe Reader, The 2nd & 3rd columns (blue text) represent what file type Adobe Reader can import and the file type that (Excel and Paint) can export into Adobe Reader. The 4th & 5th columns (green text) represent the opposite, the 4th columns represents the file types Adobe Reader can export, 5th column is what program that file type can import.

Order is important. So in the above example, (from left to right) PDF is associated with Excel (export), JPEG is exported from Paint, PDF can be imported into NitroPDF, PDF can be imported into Adobe Pro, DOC can be imported into Microsoft Word.
I have no idea how to consolidate the data I have into the 5 columns. Each specific cell (besides the 1st) will contain a significant amount of text, so looking for the best way to automatically arrange the data into this format. I don’t if its by macros, powerpivot, a 3rd party app, etc. Because as my table of data gets bigger, I would just like to have it automatically update.

Any ideas?