2 dimensional table

  1. A

    Re-organize data from a 2 dimensional grid to a single dimensional grid - see example below

    Hi Experts, I am new to this forum, I need help for following query Re-organize data from a 2 dimensional grid to a single dimensional grid - see example below source data: Item Sales MH, GJ, KA A 1 2 3 B 4 5 6 C 7 8 9 reformat to the following Item STATE Sales A MH 1 B MH 4 C MH 7 A GJ 2 B...
  2. B

    Double lookup from two dimensional table

    Hello all, I am trying to get a cell in my spreadsheet to look up a value based on two values. I have a dropdown list that lists the worksheets in the workbook, and each worksheet has a table with width measurements for the columns and height measurements for the rows. I have a function that is...

Some videos you may like

This Week's Hot Topics

Top