Hi,
Imagine a big spread sheet holding lots of data regarding customers. Each row is a different company and each column holds specific information regarding that company. I need to select certain rows and then print the company information as a summarised report. The report should consist of a table with two columns, the first column will hold the company headline info so lets say columns a, b, c and K - the data can simply be shown as follows:
(a) Company code: BBC002
(b) Company name: the fake company
(c) Company area code: GB
(k) Company description: A fake company founded in 2017 as a way of explaining myself in an Excel forum.
Then the second column for the fake company will hold more fields with more specific information as in column 1.
As I don't even know what this function is called I am unable to search for it and follow a tutorial so even if you aren't sure how to achieve it but know what I need to research that would be of great help.
Thanks
Bookmarks