Using information in certain cells to create text that can be exported to another system.

[GlasgowF]

I've seen this done before and cannot for the life of me remember how to get it up and running, so what better place to ask after being a lurker for the last 10 years or so.

Problem

I am looking to create a solution that allows me to pull specific data from cells that allows me to create reporting in text format, ideally with the cell headers corresponding

I-e -
Customer - John
Project Scope - New install
Date requested - 1st May 2021

Customer - Alice
Scope of Work - Repair

The above example is just an example I created to give an idea of what I am looking for in theory.

Also an added issue that not all information in the workbook is relevant. For each row of around 100 cells, there are maybe 20 cells that would be relevant to the scheduling ticket this is looking to create.

I know there is a few ways of doing this, so any suggestions would be much appreciated.

 

[GlasgowF]

A bump for anyone who is able to give some guidance

 

[GlasgowF]

nobody?

I've worked out a way of doing it with an unpivot but not really staff friendly. Must be an easier way?