Horizontal to vertical

[#1]

Hi All,

I have a created a straight table that looks like an image below

However,

I need it to look like something like this one

How can it be done?

[#2]

HI,

I have tried it one and it worked. However, this menu does not always pop up.

[trdandamudi]

Please make sure you have a check mark against "Always Show Design Menu Items" in user preferences under "Design" tab. see the screen shot below:

[#4]

Tahnk you very much!

[trdandamudi]

You are welcome... Glad able to help...

[Saravanan_Desingh]

If you want to combine the rows into columns, you can use Generic-Load

Data:
LOAD * INLINE [
    Grouped Status, Count
    Draft Report Delivered, 7
    In Progress, 9
    In Planning, 0
];
GenericLabel:
Generic Load  1,*
  Resident Data;
CombinedGenericTable:
Load 1 Resident Data;
FOR i = NoOfTables()-1 to 0 STEP -1
  LET vTable=TableName($(i));
  IF WildMatch('$(vTable)', 'Data.*') THEN
  LEFT JOIN ([CombinedGenericTable]) LOAD * RESIDENT [$(vTable)];
  DROP TABLE [$(vTable)];
  ENDIF
NEXT i 
Drop Table Data;