How to make from one row two?

[andrey2007]

Hello All
My table looks like these

Number Name Position Login1 Login2

1 John expert johns1 johns2

is it possible to make another table which looks like
Number Name Position Login
1 John expert johns1
2 John expert johns2

Thanks for all answers!

[krish3]

try using transpose to your result..

....your search |table....|transpose

[martin_mueller · Accepted solution]

If you have just two fields you can do this:

base search | eval Login = Login1."###".Login2 | fields - Login1 Login2 | makemv delim="###" Login | mvexpand Login

[martin_mueller]

You could insert this:

... | fillnull value="n/a" Login1 Login2 | ...

[andrey2007]

and it does not work for case like this user has only Login1 OR Login2
Number Name Position Login1 Login2

1 John expert johns2
2 Willy expert will1

[martin_mueller]

Huh? How does it work and throw an error message at the same time?

[andrey2007]

Thanks, it works!
But with message like this
Field 'Login' does not exist in the data.

[treinke]

Maybe something like this?

<your search> | rename Login1 as Login | rename Login2 as Login | sort by Login | table Number,Name,Position,Login

[andrey2007]

sorry, but not
this way table looks like
Number Name Position Login2