Visualise a dataset from where you want to create different columns for entries which are listed down in one single column. In a scenario where the entries which have to be shown under each of these columns so created are numeric, a simple Pivot Table will sufficed. However, if entries to be shown under the columns are text entries, then a Pivot Table will not work because in the Value area section of a Pivot Table, only numbers can be displayed. If a text column is dragged to the Value area section of a Pivot Table, then a count is displayed.
To create a multi column range from an existing dataset, you may refer to my solution in this workbook.
You may watch a short video of my solution here
Converting a tabular data layout to a matrix layout
{ 9 Comments }