I am writing a shell script which takes a text file as input and generate a spreadsheet as output. I have single text file similar to the one shown below.
Name:John Age:30 Gender:male Name:Bob Age:65 Gender:Male
and the pattern goes on repeating several times. I have to create a spreadsheet with name, age and gender as fields as shown below.
Name Age Gender John 30 Male Bob 65 Male
Help would be appreciated.