combination of tables across columns

1 view (last 30 days)
Hello, I have one table with the example values below:
Time1 Time2 Time3
'00:10' '00:10' '00:10'
'00:20' '00:20' '00:20'
'00:30' '00:30' '00:30'
'00:40' '00:40' '00:40'
'00:50' '00:50' '00:50'
And a second table with values:
Precipitation1 Precipitation2 Precipitation3
0,16 0 0,01
0,05 0,42 0,27
0,05 0,02 0,18
0,20 0 0,11
0,26 0 0,4
I'm looking for a combination of tables across columns that will look like:
Time1 Precipitation1 Time2 Precipitation2 Time3 Precipitation3
'00:10' 0,16 '00:10' 0 '00:10' 0,01
'00:20' 0,05 '00:20' 0,42 '00:20' 0,27
'00:30' 0,05 '00:30' 0,02 '00:30' 0,18
'00:40' 0,20 '00:40' 0 '00:40' 0,11
'00:50' 0,26 '00:50' 0 '00:50' 0,4
Thanks!!!

Accepted Answer

Stephen23
Stephen23 on 25 Oct 2020
Where T1 and T2 are your two tables:
T = [T1,T2];
T = T(:,[1,4,2,5,3,6])
  1 Comment
Legally Blonde
Legally Blonde on 25 Oct 2020
Thank you so much for the quick answer! It work! How simple. :-)

Sign in to comment.

More Answers (1)

Ameer Hamza
Ameer Hamza on 25 Oct 2020
Here T1 and T2 are two tables in your question
T = [T1 T2];
T = [T(:,1:size(T1,2):end) T(:,2:size(T1,2):end)]

Categories

Find more on Tables in Help Center and File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!