Bernhard99
New Member
- Joined
- Apr 2, 2013
- Messages
- 1
hi, I have different tables of information that I would like to merge into one large table, no calculations required.
The common demoninator i the column "project-nr". How do I do this?
I have tried to google it and have created data table relationships between the tables
but I cant seem to get this to work.
Am I on the right track If I have made a pivottable with data for the three worksheets.
The tables are like this (but much larger)
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]project nr[/TD]
[TD]location[/TD]
[TD]revenue q1[/TD]
[/TR]
[TR]
[TD]1000[/TD]
[TD]stockholm[/TD]
[TD]1500[/TD]
[/TR]
[TR]
[TD]1001[/TD]
[TD]malmo[/TD]
[TD]2000[/TD]
[/TR]
[TR]
[TD]1002[/TD]
[TD]stockholm[/TD]
[TD]2300[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]project nr[/TD]
[TD]location[/TD]
[TD]revenue q2[/TD]
[/TR]
[TR]
[/TR]
[TR]
[TD]1002[/TD]
[TD]stockholm[/TD]
[TD]2400[/TD]
[/TR]
[TR]
[TD]1003[/TD]
[TD]malmo[/TD]
[TD]1200[/TD]
[/TR]
[TR]
[TD]1004[/TD]
[TD]stockholm[/TD]
[TD]1300[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]project nr[/TD]
[TD]location[/TD]
[TD]revenue q3[/TD]
[/TR]
[TR]
[/TR]
[TR]
[TD]1001[/TD]
[TD]malmo[/TD]
[TD]2400[/TD]
[/TR]
[TR]
[TD]1005[/TD]
[TD]malmo[/TD]
[TD]1200[/TD]
[/TR]
[TR]
[TD]1006[/TD]
[TD]stockholm[/TD]
[TD]1300[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
And now I want this in one large table like this
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]project nr[/TD]
[TD]location[/TD]
[TD]rev q1[/TD]
[TD]rev q2[/TD]
[TD]rev q3[/TD]
[/TR]
[TR]
[TD]1001[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1002[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1003[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1004[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
What is the simplest way for this?
The common demoninator i the column "project-nr". How do I do this?
I have tried to google it and have created data table relationships between the tables
but I cant seem to get this to work.
Am I on the right track If I have made a pivottable with data for the three worksheets.
The tables are like this (but much larger)
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]project nr[/TD]
[TD]location[/TD]
[TD]revenue q1[/TD]
[/TR]
[TR]
[TD]1000[/TD]
[TD]stockholm[/TD]
[TD]1500[/TD]
[/TR]
[TR]
[TD]1001[/TD]
[TD]malmo[/TD]
[TD]2000[/TD]
[/TR]
[TR]
[TD]1002[/TD]
[TD]stockholm[/TD]
[TD]2300[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]project nr[/TD]
[TD]location[/TD]
[TD]revenue q2[/TD]
[/TR]
[TR]
[/TR]
[TR]
[TD]1002[/TD]
[TD]stockholm[/TD]
[TD]2400[/TD]
[/TR]
[TR]
[TD]1003[/TD]
[TD]malmo[/TD]
[TD]1200[/TD]
[/TR]
[TR]
[TD]1004[/TD]
[TD]stockholm[/TD]
[TD]1300[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]project nr[/TD]
[TD]location[/TD]
[TD]revenue q3[/TD]
[/TR]
[TR]
[/TR]
[TR]
[TD]1001[/TD]
[TD]malmo[/TD]
[TD]2400[/TD]
[/TR]
[TR]
[TD]1005[/TD]
[TD]malmo[/TD]
[TD]1200[/TD]
[/TR]
[TR]
[TD]1006[/TD]
[TD]stockholm[/TD]
[TD]1300[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
And now I want this in one large table like this
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]project nr[/TD]
[TD]location[/TD]
[TD]rev q1[/TD]
[TD]rev q2[/TD]
[TD]rev q3[/TD]
[/TR]
[TR]
[TD]1001[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1002[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1003[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1004[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
What is the simplest way for this?