Transpose Table of Data

In range G14 you have an example of the table I want.
' Note that the macro should work without any change in the VBA Code if there is more or less than 31 project and if there is
' more or less than 3 different benefits and complexity.
'
' You have to write below the VBA code to do this.

Results should appear like this.

[TABLE="class: cms_table, width: 1168"]

[tr]

[TD="colspan: 4"]Example of result of the macro[/TD]

[/tr]

[tr]

[td]

Benefit/Compexity

[/td]

[td]

Easy

[/td]

[td]

Medium

[/td]

[td]

Difficult

[/td]

[/tr]

[tr]

[td]

High

[/td]

[td]

Project_1 Project_15 Project_23

[/td]

[td]

Project_2 Project_3 Project_11 Project_2 Project_3 Project_11

[/td]

[td]

Project_5 Project_24 Project_29

[/td]

[/tr]

[tr]

[td]

Medium

[/td]

[td]

Project_4 Project_9 Project_14 Project_19 Project_28

[/td]

[td]

Project_16 Project_17 Project_16 Project_17

[/td]

[td]

Project_6 Project_12 Project_13 Project_18 Project_21 Project_22 Project_31

[/td]

[/tr]

[tr]

[td]

Low

[/td]

[td]

Project_7 Project_8 Project_10 Project_30

[/td]

[td]

Project_20 Project_26 Project_27 Project_20 Project_26 Project_27

[/td]

[td]

Project_25

[/td]

[/tr]

[/TABLE]

Data:

[TABLE="class: cms_table, width: 296"]

[tr]

[td]

Project Name

[/td]

[td]

Benefit

[/td]

[td]

Complexity

[/td]

[/tr]

[tr]

[td]

Project_1

[/td]

[td]

High

[/td]

[td]

Easy

[/td]

[/tr]

[tr]

[td]

Project_2

[/td]

[td]

High

[/td]

[td]

Medium

[/td]

[/tr]

[tr]

[td]

Project_3

[/td]

[td]

High

[/td]

[td]

Medium

[/td]

[/tr]

[tr]

[td]

Project_4

[/td]

[td]

Medium

[/td]

[td]

Easy

[/td]

[/tr]

[tr]

[td]

Project_5

[/td]

[td]

High

[/td]

[td]

Difficult

[/td]

[/tr]

[tr]

[td]

Project_6

[/td]

[td]

Medium

[/td]

[td]

Difficult

[/td]

[/tr]

[tr]

[td]

Project_7

[/td]

[td]

Low

[/td]

[td]

Easy

[/td]

[/tr]

[tr]

[td]

Project_8

[/td]

[td]

Low

[/td]

[td]

Easy

[/td]

[/tr]

[tr]

[td]

Project_9

[/td]

[td]

Medium

[/td]

[td]

Easy

[/td]

[/tr]

[tr]

[td]

Project_10

[/td]

[td]

Low

[/td]

[td]

Easy

[/td]

[/tr]

[tr]

[td]

Project_11

[/td]

[td]

High

[/td]

[td]

Medium

[/td]

[/tr]

[tr]

[td]

Project_12

[/td]

[td]

Medium

[/td]

[td]

Difficult

[/td]

[/tr]

[tr]

[td]

Project_13

[/td]

[td]

Medium

[/td]

[td]

Difficult

[/td]

[/tr]

[tr]

[td]

Project_14

[/td]

[td]

Medium

[/td]

[td]

Easy

[/td]

[/tr]

[tr]

[td]

Project_15

[/td]

[td]

High

[/td]

[td]

Easy

[/td]

[/tr]

[tr]

[td]

Project_16

[/td]

[td]

Medium

[/td]

[td]

Medium

[/td]

[/tr]

[tr]

[td]

Project_17

[/td]

[td]

Medium

[/td]

[td]

Medium

[/td]

[/tr]

[tr]

[td]

Project_18

[/td]

[td]

Medium

[/td]

[td]

Difficult

[/td]

[/tr]

[tr]

[td]

Project_19

[/td]

[td]

Medium

[/td]

[td]

Easy

[/td]

[/tr]

[tr]

[td]

Project_20

[/td]

[td]

Low

[/td]

[td]

Medium

[/td]

[/tr]

[tr]

[td]

Project_21

[/td]

[td]

Medium

[/td]

[td]

Difficult

[/td]

[/tr]

[tr]

[td]

Project_22

[/td]

[td]

Medium

[/td]

[td]

Difficult

[/td]

[/tr]

[tr]

[td]

Project_23

[/td]

[td]

High

[/td]

[td]

Easy

[/td]

[/tr]

[tr]

[td]

Project_24

[/td]

[td]

High

[/td]

[td]

Difficult

[/td]

[/tr]

[tr]

[td]

Project_25

[/td]

[td]

Low

[/td]

[td]

Difficult

[/td]

[/tr]

[tr]

[td]

Project_26

[/td]

[td]

Low

[/td]

[td]

Medium

[/td]

[/tr]

[tr]

[td]

Project_27

[/td]

[td]

Low

[/td]

[td]

Medium

[/td]

[/tr]

[tr]

[td]

Project_28

[/td]

[td]

Medium

[/td]

[td]

Easy

[/td]

[/tr]

[tr]

[td]

Project_29

[/td]

[td]

High

[/td]

[td]

Difficult

[/td]

[/tr]

[tr]

[td]

Project_30

[/td]

[td]

Low

[/td]

[td]

Easy

[/td]

[/tr]

[tr]

[td]

Project_31

[/td]

[td]

Medium

[/td]

[td]

Difficult[Blocked Image: http://www.vbaexpress.com/forum/images/smilies/banghead.gif]

[/td]

[/tr]

[/TABLE]

Re: Transpose Table of Data

I'm new to VBA.

This is the task assigned to me.

In excel, I can do it easier. Similarly, If data of Benefit and Complexity is fixed. then I am able to do it.

But dynamically, If changes. Then don't know. how to do it.

Pls help me