Forum Discussion
Data is spread in multiple rows, need to put into tabular format
Hi all, Stuck on a problem and not sure what the correct terms are in order to search the answer. I have a table with data in a journal style with duplicate lines for each product the customer ha...
=PIVOTBY(HSTACK(A2:A14,B2:B14),C2:C14,D2:D14,SUM,,0,,0)
With Office 365 you can apply PIVOTBY. However as far as i know the formula is currently only available in the insider channel. The screenshot is from Excel for the web.
