Trick to transpose data based on specific field in Excel
sometimes we stuck with issues like transposing data based on specific field in Excel.
Lets take a table for example as tagged below.
Idea to get the data transformed in below form.
To get the desired result in Microsoft Excel you must be well aware of Excel functions and their nested use. Here we apply and nested formula to get the desired result.
So apply above formula if you go stuck with such issues.
Best Excel training institute in Noida provides Basic Excel, Advance Excel and VBA offline and online classes.
If you want to learn Excel & VBA courses to be excel expert, connect us on:
9599408486 / 8929231250